
package com.be.beadmin.material.repository;

import com.be.beadmin.material.entity.PickingOverView;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

/**
* @author zmy
* @date 2023-05-14
**/
public interface PickingOverViewRepository extends JpaRepository<PickingOverView, String>, JpaSpecificationExecutor<PickingOverView> {

    PickingOverView findPickingOverViewByIdAndDelete(String id, Integer delete);
//    @Query(value = "select pow.picking_no from t_om_picking_over_view pow where pow.product_code = ?1 and pow.is_delete = ?2",nativeQuery = true)
//    String findPickingNoProductCodeAndDelete(String productCode, Integer delete);

    PickingOverView findPickingOverViewByProductCodeAndDelete(String productCode, Integer delete);
    PickingOverView findPickingOverViewById(String id);

    PickingOverView findPickingOverViewByProductCodeAndAndPickingNoAndDelete(String productCode,String pickingNo,Integer delete);

}